IIF doesnt work? Variant-Error?

SlashmasterSlashmaster
edited 10:25AM in FastReport 4.0
Hello again,

in my Memo i want to check, if more then 1 Record is counting.

[COUNT(MasterData2)]
works (for example Result is 26)

if i try this
[IIF(26=26,"(en)","(n)")]
works it too even if i write 26=25 -> Result is "(n)"

But i cant combinate both formulas
[IIF([COUNT(MasterData2)]=26,"(en)","(n)")]
-> Result ERROR

Why and what could i try? Thx a lot!

Comments

  • gordkgordk St.Catherines On. Canada.
    edited 10:25AM
    first i suggest you read the usermanual on aggregate functions
    they are for use in summary type bands footers group footers and page footers column footers and
    summary bands.

    2nd your syntax is incorrect
    in any given expression you are only allowed one set of [ ] braces
    [IIF([COUNT(MasterData2)]=26,"(en)","(n)")] wrong.

    [IIF(COUNT(MasterData2) = 26,"(en)","(n)")] correct.

    BTW these are expressions not code
  • SlashmasterSlashmaster
    edited 10:25AM
    Hello gordk,

    well, my english issn't good as it should be.. so i red the manuels but misunderstood that the whole expressions must be in [ ]. I thought each "variable" or expression embed in [ ]. [img]style_emoticons/<#EMO_DIR#>/wacko.gif" style="vertical-align:middle" emoid=":wacko:" border="0" alt="wacko.gif" /> Thank u very much![/img]>

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.

Home • FastReport 4.0Comment As ...

© Vanilla Keystone Theme 2024